Displaying Lookup windows
Use the data control in any Lookup window to move through records. You can also simply begin typing a search term in a data control box. The Lookup windows display only the records that begin with the characters you type, filtering more effectively as you continue typing.
After you locate the data, you can insert it in the appropriate text box or cell.
To display a Lookup window, do any of the following:
- Click the drop-down arrow in the data control.
- Click the drop-down arrow next to the text box.
- Right-click in a cell of a column, and then select a window from the menu.
- Select a cell and press the F5, F6, F8, or Shift+? keys.
-
Select a cell, enter a word or partial word, and then press F5 or Shift+?.
The Lookup window displays the first occurrence found in the database.
-
Select a cell, type a wildcard, enter a word or partial word, and then press F4.
The Lookup window displays every occurrence found in the database.
- Double-click the cell or column title.
- Select the cell or column and click the drop-down arrow in the cell.